﻿CREATE TABLE [aud].[DataAudit] (
    [DataAuditId]        INT              IDENTITY (1, 1) NOT NULL,
    [FileName]           NVARCHAR (200)   NULL,
    [PackageExecutionId] UNIQUEIDENTIFIER NULL,
    [UserName]           NVARCHAR (50)    NULL,
    [Result]             CHAR (1)         NULL,
    [CreatedDate]        DATETIME         DEFAULT (getdate()) NOT NULL,
    PRIMARY KEY CLUSTERED ([DataAuditId] ASC) WITH (FILLFACTOR = 90, ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

